github.com/turbot/steampipe@v1.7.0-rc.0.0.20240517123944-7cef272d4458/tests/manual_testing/many controls/queries/q16.sql (about)

     1  select
     2      -- Required Columns
     3      autoscaling_group_arn as resource,
     4      case
     5          when load_balancer_names is null and target_group_arns is null then 'alarm'
     6          when health_check_type != 'ELB' then 'alarm'
     7          else 'ok'
     8          end as status,
     9      case
    10          when load_balancer_names is null and target_group_arns is null then title || ' not associated with a load balancer.'
    11          when health_check_type != 'ELB' then title || ' does not use ELB health check.'
    12          else title || ' uses ELB health check.'
    13          end as reason,
    14      -- Additional Dimensions
    15      region,
    16      account_id
    17  from
    18      aws_ec2_autoscaling_group;